﻿CREATE TABLE [dbo].[Person]
(
	perid int identity,
	firstname varchar(64) not null,
	middlename varchar(64) not null,
	sirname varchar(64) not null,
	approxHours int not null,
	username varchar(32) unique not null,
	password varchar(32) not null,
	suffix varchar(16) not null,
	homephone varchar(16) not null,
	cellphone varchar(16) not null,
	address varchar(128) not null,
	active smallint default 1,
	manager smallint default 0,
	primary key (perid)
)
